
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE [dbo].gspSiteEvent_UPDATE
(
@eventId int = null,
@title nvarchar(150) = null,
@eventPlace nvarchar(300) = null,
@eventContent nvarchar(MAX) = null,
@eventTypeCode int = null,
@membersCount int = null,
@startDate datetime = null,
@finishDate datetime = null,
@isDeleted bit = null,
@isVisible bit = null,
@createDate datetime = null,
@lastModifiedDate datetime = null
)
AS

UPDATE
  [dbo].[SiteEvent]
SET
  [Title] = @title,
  [EventPlace] = @eventPlace,
  [EventContent] = @eventContent,
  [EventTypeCode] = @eventTypeCode,
  [MembersCount] = @membersCount,
  [StartDate] = @startDate,
  [FinishDate] = @finishDate,
  [IsDeleted] = @isDeleted,
  [IsVisible] = @isVisible,
  [CreateDate] = @createDate,
  [LastModifiedDate] = @lastModifiedDate
WHERE
  [EventId] = @eventId

GO
